use Formality
go

create table Players (
	PlayerId int not null identity primary key,
	Problem nvarchar(32) not null,
	Name nvarchar(255) not null,
	unique(Name)
)

create table Submissions (
	SubmissionId int not null identity primary key,	
	PlayerId int not null references Players,
	ProblemId nvarchar(32) not null,
	Sentence ntext not null,
	SubmissionOrder int not null 
)

